home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker And Apple Events / Sample Applications / Copying Records / Copy Original To Archive < prev    next >
Text File  |  1996-01-25  |  481b  |  12 lines
  1. tell application "FileMaker Pro"
  2.     go to database "Source Database"
  3.     go to layout "Data Entry"
  4.     show (every record of database "Source Database" whose first cell = "Fred")
  5.     sort first layout of window "Source Database" by field "Last Name"
  6.     set recordsFound to every record of document "Source Database"
  7.     repeat with i in recordsFound
  8.         create record at layout "Data Entry" of database "Archive Database" with data i
  9.     end repeat
  10.     go to database "Archive Database"
  11.     activate
  12. end tell